/*
 * Licensed under the Apache License, Version 2.0 (the "License");
 * you may not use this file except in compliance with the License.
 * You may obtain a copy of the License at
 *
 * http://www.apache.org/licenses/LICENSE-2.0
 *
 * Unless required by applicable law or agreed to in writing, software
 * distributed under the License is distributed on an "AS IS" BASIS,
 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 * See the License for the specific language governing permissions and
 * limitations under the License.
 */
package org.jdbi.v3.oracle12;

import java.sql.Connection;
import java.sql.SQLException;

import javax.sql.DataSource;

import oracle.jdbc.pool.OracleDataSource;
import org.jdbi.v3.core.Jdbi;
import org.jdbi.v3.testing.JdbiRule;
import org.testcontainers.containers.OracleContainer;

/**
 * JUnit 4 Helper for a database managed by testcontainers.
 */
public class OracleDatabaseRule extends JdbiRule {

    private final String uri;
    private final String username;
    private final String password;

    public OracleDatabaseRule(OracleContainer oracleContainer) {
        this.uri = oracleContainer.getJdbcUrl();
        this.username = oracleContainer.getUsername();
        this.password = oracleContainer.getPassword();
    }

    @Override
    protected DataSource createDataSource() {
        try {
            OracleDataSource dataSource = new OracleDataSource();
            dataSource.setURL(uri);
            dataSource.setUser(username);
            dataSource.setPassword(password);

            return dataSource;
        } catch (SQLException e) {
            throw new IllegalStateException(e);
        }
    }

    public static void createTables(OracleContainer oracleContainer) throws SQLException {
        try (Connection connection = oracleContainer.createConnection("")) {
            Jdbi jdbi = Jdbi.create(connection);

            jdbi.withHandle(handle -> {
                handle.execute("create sequence something_id_sequence INCREMENT BY 1 START WITH 100");
                handle.execute("create table something (name varchar(200), id int, constraint something_id primary key (id))");
                return null;
            });
        }
    }
}
